{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["_Intructions_Export","file_information","noise_register_data","vocabularies"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"_Intructions_Export","index":0,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[19,1,19,14]]}
[null,"Impulsive Noise register data"]
[]
[null,"This file converts data to an XML file that can be uploaded to the Impulsive noise register database. "]
[]
[null,"1) COPY YOUR DATA INTO THE EXCEL FILE tabs:"]
[]
[null,null,"There are 3 tabs; file information should always be filled in. Data point and Data polygon can both be filled in, or just one of these worksheets can be filled in"]
[null,null,"worksheet tab: file_information",null,null,null,null,"This worksheet should always be filled in"]
[null,null,"worksheet tab: Noise_Register_Data",null,null,null,null,"This worksheet should always be filled in"]
[null,null,"worksheet tab: vocabularies",null,null,null,null,"This worksheet is for reference purposes, do not edit."]
[]
[null,null,"All red outlined cells are mandatory and should be checked / filled in",null,null,null,null,null,null,"*"]
[]
[null,null,"All green outlined cells are optional "]
[]
[]
[null,"2) Use the button here to export the completed Excel data template to XML."]
[]
[]
[null,"3) The vocabularies are included as a worksheet tab. These are the valid codes for use in the drop down boxes in the spreadsheet fields. The vocabularies on the vocabulary worksheet will also be available on the ICES Vocab server (once finalized). The latest versions of the vocabularies will be the ones available via the URL below. It may be that from time to time the lists are updated on the vocab server, so it is always best to check that you have the latest version of the Excel spreadsheet"]
[null,"http://vocab.ices.dk"]
[]
[null,"4) Go to this website  where you can upload your XML data file, and also check the latest versions of the Excel spreadsheet and XML Schema."]
[null,"http://underwaternoise.ices.dk"]
[]
[]
[null,"* for reporting of polygon/point (lat/lon/geometry_type/Polygon_ID) all are marked as mandatory but "]
[null,"Point source data will be reported by filling Latitude, Longitude and Geometry type: point. "]
[null,"Polygon source data can be reported in two ways; by entering the Latitude and Longitude of the centroid of the polygon and selecting the appropriate polygon type from Geometry_type. "]
[null,"Alternatively, these fields can be left blank and the identifier for the polygon can be entered in the polygon_ID field"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,".."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"drop downs - ZZ100"]

{"sheet":"file_information","index":1,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Country (ISO 1366 code)","Preparation Date (ddmmyyyy)","Organization (EDMO code)"]

{"sheet":"noise_register_data","index":2,"n_rows":3,"n_cols":25,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Station",null,null,null,null,null,"Event",null,null,null,"Mitigation",null,null,null,null,null,null,null,"Optional attributes"]
["data_entry_point_ID (string)","start_date (ddmmyyyy)","end_date (ddmmyyyy)","Latitude (WGS84)","Longitude (WGS84)","Geometry_type (Point, Uk license blocks, ICES sub-rectangles, German naval polygon)","polygon_ID                               (ICES sub-rectangle ID or Regional Polygon ID)","source_event (vocab list)","value_code (from list: NA/very_low/low/medium/high/very_high)","sound_mitigation_bool (yes/no)","NMS_type (from list: BBC/SBC/IHC/HSD/HEP/COF/CBBCIHC/CBBCHSD/CBBCCOF/Other)","sound_measurement_bool (yes/no)","SEL (dB re 1µPa²s)\n","Lpeak (dB re 1µPa)","distance_to_pile (metres, decimal))","type_hammer (Model number of hammer used, e.g. S-2000, 3000S)","max_energy (Kj)","source_spectra (UNIT to be determined)","duty_cycle (decimal)","start_time (hhmm)","duration (seconds, integer)","directivity (decimal)","source_depth (metres, decimal)","platform_speed (Knots, decimal)","remarks (free text)"]

{"sheet":"vocabularies","index":3,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["value_code","Sonar or acoustic deterrents (source level, rounded to nearest decibel)","Generic explicitly impulsive source (energy source level, rounded to nearest decibel)","Airgun arrays (zero to peak source level, rounded to nearest decibel): ","Explosions (equivalent TNT charge mass, rounded to nearest 10 g if less than 10 kg and to nearest 1 kg otherwise)","Impact pile driver (hammer energy, rounded to nearest 10 kJ) ",null,"ISO Country Codes","Country",null,"Source Event",null,"EDMO code","EDMOD Code Description",null,"Yes/No type",null,"Types of noise mitigation systems ",null,null,"Geometry_type"]
["NA",null,null,null,null,null,null,"BE","Belgium",null,"Airgun_arrays",null,"EDMO code","EDMOD Code Description",null,"Yes",null,"NMS_Type","Description",null,"Point"]
["very_low","176-200 dB re 1 μPa m ","186-210 dB re 1 μPa2 m2 s ","209-233 dB re 1 μPa m ","8 g to 210 g ","< 280 kJ ",null,"DE","Germany",null,"Explosions",null,1368,"Alfred Wegener Institut Helmholtz Center for Polar and Marine Research",null,"No",null,"BBC","Big Bubble Curtain",null,"ICES_SubRectangle"]
["low","201-210 dB re 1 μPa m ","211-220 dB re 1 μPa2 m2 s ","234-243 dB re 1 μPa m ","220 g - 2.1 kg ","290 kJ - 2.80 MJ ",null,"DK","Denmark",null,"Generic_explicitly_impulsive_source",null,396,"Marine Institute (MI)",null,null,null,"SBC","Small Bubble Curtain",null,"UK_Licence_Blocks"]
["medium","211-220 dB re 1 μPa m ","221-230 dB re 1 μPa2 m2 s ","244-253 dB re 1 μPa m ","2.11 kg - 21 kg ","2.81 - 28 MJ ",null,"EE ","Estonia",null,"Impact_pile_driver",null,411,"Environmental Protection Agency ",null,null,null,"IHC","I H C - Noise Mitigation System",null,"German_Naval_Polygon"]
["high","> 220 dB re 1 μPa m ","> 230 dB re 1 μPa2 m2 s ","> 253 dB re 1 μPa m","22 kg - 210 kg ","> 28 MJ ",null,"ES","Spain",null,"Sonar_or_acoustic_deterrents",null,457,"Danish Forest and Nature Agency ",null,null,null,"HSD","HydroSoundDamper"]
["very_high",null,null,null,"> 210 kg ",null,null,"FI","Finland",null,null,null,540,"Shom (Shom)",null,null,null,"HEP","Pile-in-Pile Jacket"]
[null,null,null,null,null,null,null,"FR","France",null,null,null,680,"Department of Marine Research of the Environmental Protection Agency",null,null,null,"COF","Cofferdamm"]
[null,null,null,null,null,null,null,"GB","Great Britain",null,null,null,713,"Marine Systems Institute at Tallinn University of Technology",null,null,null,"CBBCIHC","Combined BBC and I H C-NMS"]
[null,null,null,null,null,null,null,"IE","Ireland",null,null,null,1375,"Joint Nature Conservation Committee - Aberdeen Office (JNCC) ",null,null,null,"CBBCHSD","Combined BBC and HSD"]
[null,null,null,null,null,null,null,"LT","Lituania",null,null,null,1526,"Rijkswaterstaat Water, Traffic and Environment",null,null,null,"CBBCCOF","Combined BBC and Cofferdamm"]
[null,null,null,null,null,null,null,"LV","Latvia",null,null,null,1850,"Federal Maritime and Hydrographic Agency (BSH) ",null,null,null,"Other","Other system or other combination"]
[null,null,null,null,null,null,null,"NL","Netherlands",null,null,null,2381,"National Parks & Wildlife Service "]
[null,null,null,null,null,null,null,"PT ","Portugal",null,null,null,2746,"Joint Nature Conservation Committee - Peterborough Office (JNCC) "]
[null,null,null,null,null,null,null,"PL","Poland",null,null,null,2803,"Directorate for Coast and Sea Sustainability. Ministry of Agriculture, Food and Environment (MAGRAMA)"]
[null,null,null,null,null,null,null,"RU","Russia",null,null,null,3316,"Department of Environment, Community & Local Government "]
[null,null,null,null,null,null,null,"SE","Sweden",null,null,null,3327,"Royal Belgian Institute of Natural Sciences, Operational Directorate Natural Environment (RBINS-ODNATURE-Gulledelle)"]
[null,null,null,null,null,null,null,null,null,null,null,null,3400,"Tallinn University of Technology (TUT)"]
[null,null,null,null,null,null,null,null,null,null,null,null,3512,"The Swedish Agency for Marine and Water Management (SWAM) "]
[null,null,null,null,null,null,null,null,null,null,null,null,4477,"Danish Energy Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,2947,"GEOMAR Helmholtz Centre for Ocean Research Kiel (GEOMAR)"]
[null,null,null,null,null,null,null,null,null,null,null,null,1368,"Alfred Wegener Institut Helmholtz Center for Polar and Marine Research"]